const express = require("express");
const conn = require("./mysql.js");
const app = express();
const port = 8080;

const users = [ {username:'admin',password:'password123'} ];

app.get("/login",(req,res) => {
    //判断
    // let user = users.find(u => u.username == req.query.uname && u.password == req.query.upwd);
    // 通过连接对象执行连接
    conn.connect((err) => {
    if (err) {
      console.error("1." + err.message);
    } else {
      console.log("1.连接成功！");
    }
  });

  //定义SQL查询
  let sql = "select * from user where username ='" + req.query.uname + "'and password ='" + req.query.upwd + "';";

  //执行SQL
  conn.query(sql,(err,result)=>{
    if(err){
        console.error("2." + err.message);
    }else{
        if (result.length > 0) {
            res.json({ code:200, msg:"登录成功"});
        } else {
            res.json({ code:401, msg:"用户名或密码错误"});
        }
    }
  })
});

app.listen(port,() => {
    console.log("监听端口" + port);
})
